package com.logic.landseaserver.persistence.read;

import java.util.List;

import com.logic.common.util.QueryUtil;
import com.logic.landseaserver.domain.Procedure;
import com.logic.landseaserver.ws.dto.ProcedureDTO;

public interface ProcedureReadMapper {

    Procedure selectByPrimaryKey(Integer id);

    List<Procedure> getProcedureList(QueryUtil queryUtil);

	List<ProcedureDTO> getProcedureDTOList(QueryUtil queryUtil);

	ProcedureDTO selectDTOByPrimaryKey(Integer procedureId);

	List<ProcedureDTO> queryByProjectId(QueryUtil queryUtil);

	List<Procedure> getByProjectId(Integer projectId);

	Integer countByProjectId(Integer projectId);

	Integer sumDurationByProjectId(Integer projectId);

	Procedure selectByName(String name);

	//计算已完成的工序
	Integer getStatus(String serialNum);

	//计算总工序
	Integer getTotalProcedure(String serialNum);

	//获取当前正在进行的项目工序
	ProcedureDTO getProcedureName(Integer projectId);

	Procedure getByCheckId(Integer checkId);

	List<Procedure> notPassedProcedure(Integer projectId);

}